Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
InventoryControlDocumentID (FK)(PK) | The reference number that uniquely identifies the InventoryControlDocument. | ID_ICD | Identity | integer | |
InventoryControlDocumentLineItemID (FK)(PK) | A unique system assigned identifier for the LineItem within the confines of the InventoryControlDocument. | IC_LTM_ICD | LineNumber | smallint | |
ICDChargeAllowanceProcessingRuleID (FK) | A unique system assigned identifier for the rule denoting how a particular Charge or Allowance in an InventoryControlDocument is to be treated in the financial reporting systems. | ID_ICD_CHG_ALW_RU | Identity | integer | ICDChargeAllowanceProcessingRule(RU_ICD_CHG_ALW) |
Amount | The monetary allowance made by the supplier against a specific line on the INVENTORY CONTROL DOCUMENT. | MO_ITM_LN_ALW | Money | decimal(16,5) | |
TypeCode | This code defines the type of allowance. For ARTS purposes the UCC-defined codes, data elements 150 and 340, are used as the basis for the domain of this attribute. | TY_ITM_LN_ALW | Code2 | char(2) | |
ReasonCode | The reason code for applying the allowance. | RC_ALW_IDC | Code2 | char(2) | |
SupplierAllowanceNumber | The number or identifier assigned by the supplier referencing an allowance, promotion or deal. | ID_ALW_SPR | IdentityAlphaNumeric | varchar(20) | |
RetailerSerialFormID | An idenfier for this document, usually preprinted on the form stock prior to being filled out. | ID_FRM_RTL | IdentityAlphaNumeric | varchar(20) | |